SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspProduct_INSERT
(
@productCategoryId AS int = null,
@name AS nvarchar(128) = null,
@price AS money = null,
@quantity AS int = null,
@description AS nvarchar(4000) = null,
@createdDate AS datetime = null,
@lastModifiedDate AS datetime = null,
@isDeleted AS bit = null,
@isVisible AS bit = null
)
AS

INSERT INTO
  [dbo].[Product]
(
  [ProductCategoryId],
  [Name],
  [Price],
  [Quantity],
  [Description],
  [CreatedDate],
  [LastModifiedDate],
  [IsDeleted],
  [IsVisible]
)
VALUES
(
  @productCategoryId,
  @name,
  @price,
  @quantity,
  @description,
  @createdDate,
  @lastModifiedDate,
  @isDeleted,
  @isVisible
)

SELECT SCOPE_IDENTITY()


GO
